How to use self join in sql server and what's it's important.

Question

AVADHESH PATEL · Answer

Self Join
Self join correlates rows of a table with the other rows of the same table. It is used when a table has to be joined to itself to produce results.Example
First you have to create a table EmpTable and enter the details like this:EmpID	EmpName	EmpMgrID1		Smith		2	2		Sai			33		Suresh		14		Bill			25		Steve		4SELECT E2.EMPNAME,E1.EMPNAME as 'MANAGER'FROM EmpTable E1INNER JOIN EmpTable E2ON E1.EMPID=E2.EMPMGRID
OutputEmpName	ManagerSuresh		SmithSmith		SaiBill			SaiSai			SureshSteve		Bill

forum

How to use self join in sql server and what's it's important.

Anonymous User

Can you answer this question?

1 Answers

Liked By